/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : localhost:3306
 Source Schema         : zero

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001

 Date: 29/01/2024 14:27:41
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for backend_access_log
-- ----------------------------
DROP TABLE IF EXISTS `backend_access_log`;
CREATE TABLE `backend_access_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of backend_access_log
-- ----------------------------
BEGIN;
INSERT INTO `backend_access_log` VALUES (1, 1, '172.24.0.1', '2024-01-29 06:01:30', '2024-01-29 06:01:30');
COMMIT;

-- ----------------------------
-- Table structure for backend_user_groups
-- ----------------------------
DROP TABLE IF EXISTS `backend_user_groups`;
CREATE TABLE `backend_user_groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `is_new_user_default` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_unique` (`name`),
  KEY `code_index` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of backend_user_groups
-- ----------------------------
BEGIN;
INSERT INTO `backend_user_groups` VALUES (1, 'Owners', '2024-01-29 05:49:29', '2024-01-29 05:49:29', 'owners', 'Default group for website owners.', 0);
COMMIT;

-- ----------------------------
-- Table structure for backend_user_preferences
-- ----------------------------
DROP TABLE IF EXISTS `backend_user_preferences`;
CREATE TABLE `backend_user_preferences` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `namespace` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `group` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `item` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `user_item_index` (`user_id`,`namespace`,`group`,`item`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of backend_user_preferences
-- ----------------------------
BEGIN;
INSERT INTO `backend_user_preferences` VALUES (1, 1, 'backend', 'backend', 'preferences', '{\"locale\":\"zh-cn\",\"fallback_locale\":\"en\",\"timezone\":\"Asia\\/Shanghai\",\"editor_font_size\":\"12\",\"editor_word_wrap\":\"fluid\",\"editor_code_folding\":\"manual\",\"editor_tab_size\":\"4\",\"editor_theme\":\"twilight\",\"editor_show_invisibles\":\"0\",\"editor_highlight_active_line\":\"1\",\"editor_use_hard_tabs\":\"0\",\"editor_show_gutter\":\"1\",\"editor_auto_closing\":\"0\",\"editor_autocompletion\":\"manual\",\"editor_enable_snippets\":\"0\",\"editor_display_indent_guides\":\"0\",\"editor_show_print_margin\":\"0\",\"user_id\":1}');
COMMIT;

-- ----------------------------
-- Table structure for backend_user_roles
-- ----------------------------
DROP TABLE IF EXISTS `backend_user_roles`;
CREATE TABLE `backend_user_roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `permissions` text COLLATE utf8mb4_unicode_ci,
  `is_system` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `role_unique` (`name`),
  KEY `role_code_index` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of backend_user_roles
-- ----------------------------
BEGIN;
INSERT INTO `backend_user_roles` VALUES (1, 'Publisher', 'publisher', 'Site editor with access to publishing tools.', '', 1, '2024-01-29 05:49:29', '2024-01-29 05:49:29');
INSERT INTO `backend_user_roles` VALUES (2, 'Developer', 'developer', 'Site administrator with access to developer tools.', '', 1, '2024-01-29 05:49:29', '2024-01-29 05:49:29');
COMMIT;

-- ----------------------------
-- Table structure for backend_user_throttle
-- ----------------------------
DROP TABLE IF EXISTS `backend_user_throttle`;
CREATE TABLE `backend_user_throttle` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned DEFAULT NULL,
  `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attempts` int(11) NOT NULL DEFAULT '0',
  `last_attempt_at` timestamp NULL DEFAULT NULL,
  `is_suspended` tinyint(1) NOT NULL DEFAULT '0',
  `suspended_at` timestamp NULL DEFAULT NULL,
  `is_banned` tinyint(1) NOT NULL DEFAULT '0',
  `banned_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `backend_user_throttle_user_id_index` (`user_id`),
  KEY `backend_user_throttle_ip_address_index` (`ip_address`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of backend_user_throttle
-- ----------------------------
BEGIN;
INSERT INTO `backend_user_throttle` VALUES (1, 1, '172.24.0.1', 0, NULL, 0, NULL, 0, NULL);
COMMIT;

-- ----------------------------
-- Table structure for backend_users
-- ----------------------------
DROP TABLE IF EXISTS `backend_users`;
CREATE TABLE `backend_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `login` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `activation_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `persist_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reset_password_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `permissions` text COLLATE utf8mb4_unicode_ci,
  `metadata` mediumtext COLLATE utf8mb4_unicode_ci,
  `is_activated` tinyint(1) NOT NULL DEFAULT '0',
  `role_id` int(10) unsigned DEFAULT NULL,
  `activated_at` timestamp NULL DEFAULT NULL,
  `last_login` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `is_superuser` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `login_unique` (`login`),
  UNIQUE KEY `email_unique` (`email`),
  KEY `act_code_index` (`activation_code`),
  KEY `reset_code_index` (`reset_password_code`),
  KEY `admin_role_index` (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of backend_users
-- ----------------------------
BEGIN;
INSERT INTO `backend_users` VALUES (1, 'Admin', 'Person', 'admin', 'admin@example.com', '$2y$10$6i7m5u/Aoc4K7CqK8hCMOOrNEF4bV1lLVJ/S55/4O6DybjEl9/AH.', NULL, '$2y$10$H/8NochTcOgNwBLPmd65x.JkVjuXcqqGhTgaY8Whn7WGRjX2gyNcu', NULL, '', NULL, 1, 2, NULL, '2024-01-29 06:20:37', '2024-01-29 05:49:29', '2024-01-29 06:20:37', NULL, 1);
COMMIT;

-- ----------------------------
-- Table structure for backend_users_groups
-- ----------------------------
DROP TABLE IF EXISTS `backend_users_groups`;
CREATE TABLE `backend_users_groups` (
  `user_id` int(10) unsigned NOT NULL,
  `user_group_id` int(10) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`user_id`,`user_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of backend_users_groups
-- ----------------------------
BEGIN;
INSERT INTO `backend_users_groups` VALUES (1, 1, NULL);
COMMIT;

-- ----------------------------
-- Table structure for cache
-- ----------------------------
DROP TABLE IF EXISTS `cache`;
CREATE TABLE `cache` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int(11) NOT NULL,
  UNIQUE KEY `cache_key_unique` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for cms_theme_data
-- ----------------------------
DROP TABLE IF EXISTS `cms_theme_data`;
CREATE TABLE `cms_theme_data` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `theme` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data` mediumtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cms_theme_data_theme_index` (`theme`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for cms_theme_logs
-- ----------------------------
DROP TABLE IF EXISTS `cms_theme_logs`;
CREATE TABLE `cms_theme_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `theme` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `template` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `old_template` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `old_content` longtext COLLATE utf8mb4_unicode_ci,
  `user_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cms_theme_logs_type_index` (`type`),
  KEY `cms_theme_logs_theme_index` (`theme`),
  KEY `cms_theme_logs_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for cms_theme_templates
-- ----------------------------
DROP TABLE IF EXISTS `cms_theme_templates`;
CREATE TABLE `cms_theme_templates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `source` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_size` int(10) unsigned NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cms_theme_templates_source_index` (`source`),
  KEY `cms_theme_templates_path_index` (`path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for deferred_bindings
-- ----------------------------
DROP TABLE IF EXISTS `deferred_bindings`;
CREATE TABLE `deferred_bindings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `master_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `master_field` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slave_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slave_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pivot_data` mediumtext COLLATE utf8mb4_unicode_ci,
  `session_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_bind` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `deferred_bindings_master_type_index` (`master_type`),
  KEY `deferred_bindings_master_field_index` (`master_field`),
  KEY `deferred_bindings_slave_type_index` (`slave_type`),
  KEY `deferred_bindings_slave_id_index` (`slave_id`),
  KEY `deferred_bindings_session_key_index` (`session_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for failed_jobs
-- ----------------------------
DROP TABLE IF EXISTS `failed_jobs`;
CREATE TABLE `failed_jobs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci,
  `failed_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for job_batches
-- ----------------------------
DROP TABLE IF EXISTS `job_batches`;
CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for jobs
-- ----------------------------
DROP TABLE IF EXISTS `jobs`;
CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_reserved_at_index` (`queue`,`reserved_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for migrations
-- ----------------------------
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of migrations
-- ----------------------------
BEGIN;
INSERT INTO `migrations` VALUES (1, '2013_10_01_000001_Db_Deferred_Bindings', 1);
INSERT INTO `migrations` VALUES (2, '2013_10_01_000002_Db_System_Files', 1);
INSERT INTO `migrations` VALUES (3, '2013_10_01_000003_Db_System_Plugin_Versions', 1);
INSERT INTO `migrations` VALUES (4, '2013_10_01_000004_Db_System_Plugin_History', 1);
INSERT INTO `migrations` VALUES (5, '2013_10_01_000005_Db_System_Settings', 1);
INSERT INTO `migrations` VALUES (6, '2013_10_01_000006_Db_System_Parameters', 1);
INSERT INTO `migrations` VALUES (7, '2013_10_01_000007_Db_System_Add_Disabled_Flag', 1);
INSERT INTO `migrations` VALUES (8, '2013_10_01_000008_Db_System_Mail_Templates', 1);
INSERT INTO `migrations` VALUES (9, '2013_10_01_000009_Db_System_Mail_Layouts', 1);
INSERT INTO `migrations` VALUES (10, '2014_10_01_000010_Db_Jobs', 1);
INSERT INTO `migrations` VALUES (11, '2014_10_01_000011_Db_System_Event_Logs', 1);
INSERT INTO `migrations` VALUES (12, '2014_10_01_000012_Db_System_Request_Logs', 1);
INSERT INTO `migrations` VALUES (13, '2014_10_01_000013_Db_System_Sessions', 1);
INSERT INTO `migrations` VALUES (14, '2015_10_01_000014_Db_System_Mail_Layout_Rename', 1);
INSERT INTO `migrations` VALUES (15, '2015_10_01_000015_Db_System_Add_Frozen_Flag', 1);
INSERT INTO `migrations` VALUES (16, '2015_10_01_000016_Db_Cache', 1);
INSERT INTO `migrations` VALUES (17, '2015_10_01_000017_Db_System_Revisions', 1);
INSERT INTO `migrations` VALUES (18, '2015_10_01_000018_Db_FailedJobs', 1);
INSERT INTO `migrations` VALUES (19, '2016_10_01_000019_Db_System_Plugin_History_Detail_Text', 1);
INSERT INTO `migrations` VALUES (20, '2016_10_01_000020_Db_System_Timestamp_Fix', 1);
INSERT INTO `migrations` VALUES (21, '2017_08_04_121309_Db_Deferred_Bindings_Add_Index_Session', 1);
INSERT INTO `migrations` VALUES (22, '2017_10_01_000021_Db_System_Sessions_Update', 1);
INSERT INTO `migrations` VALUES (23, '2017_10_01_000022_Db_Jobs_FailedJobs_Update', 1);
INSERT INTO `migrations` VALUES (24, '2017_10_01_000023_Db_System_Mail_Partials', 1);
INSERT INTO `migrations` VALUES (25, '2017_10_23_000024_Db_System_Mail_Layouts_Add_Options_Field', 1);
INSERT INTO `migrations` VALUES (26, '2021_10_01_000025_Db_Add_Pivot_Data_To_Deferred_Bindings', 1);
INSERT INTO `migrations` VALUES (27, '2022_08_06_000026_Db_System_Add_App_Birthday_Date', 1);
INSERT INTO `migrations` VALUES (28, '2022_10_14_000027_Db_Jobs_FailedJobs_Update', 1);
INSERT INTO `migrations` VALUES (29, '2023_09_24_000028_Db_System_Sessions_Indexes', 1);
INSERT INTO `migrations` VALUES (30, '2023_10_20_000029_Db_Jobs_Batches', 1);
INSERT INTO `migrations` VALUES (31, '2013_10_01_000001_Db_Backend_Users', 2);
INSERT INTO `migrations` VALUES (32, '2013_10_01_000002_Db_Backend_User_Groups', 2);
INSERT INTO `migrations` VALUES (33, '2013_10_01_000003_Db_Backend_Users_Groups', 2);
INSERT INTO `migrations` VALUES (34, '2013_10_01_000004_Db_Backend_User_Throttle', 2);
INSERT INTO `migrations` VALUES (35, '2014_01_04_000005_Db_Backend_User_Preferences', 2);
INSERT INTO `migrations` VALUES (36, '2014_10_01_000006_Db_Backend_Access_Log', 2);
INSERT INTO `migrations` VALUES (37, '2014_10_01_000007_Db_Backend_Add_Description_Field', 2);
INSERT INTO `migrations` VALUES (38, '2015_10_01_000008_Db_Backend_Add_Superuser_Flag', 2);
INSERT INTO `migrations` VALUES (39, '2016_10_01_000009_Db_Backend_Timestamp_Fix', 2);
INSERT INTO `migrations` VALUES (40, '2017_10_01_000010_Db_Backend_User_Roles', 2);
INSERT INTO `migrations` VALUES (41, '2018_12_16_000011_Db_Backend_Add_Deleted_At', 2);
INSERT INTO `migrations` VALUES (42, '2023_02_16_000012_Db_Backend_Add_User_Metadata', 2);
INSERT INTO `migrations` VALUES (43, '2023_09_09_000013_Db_Backend_Add_Users_Groups_Delete_At', 2);
INSERT INTO `migrations` VALUES (44, '2014_10_01_000001_Db_Cms_Theme_Data', 3);
INSERT INTO `migrations` VALUES (45, '2016_10_01_000002_Db_Cms_Timestamp_Fix', 3);
INSERT INTO `migrations` VALUES (46, '2017_10_01_000003_Db_Cms_Theme_Logs', 3);
INSERT INTO `migrations` VALUES (47, '2018_11_01_000001_Db_Cms_Theme_Templates', 3);
COMMIT;

-- ----------------------------
-- Table structure for sessions
-- ----------------------------
DROP TABLE IF EXISTS `sessions`;
CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` text COLLATE utf8mb4_unicode_ci,
  `last_activity` int(11) DEFAULT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  UNIQUE KEY `sessions_id_unique` (`id`),
  KEY `sessions_last_activity_index` (`last_activity`),
  KEY `sessions_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for system_event_logs
-- ----------------------------
DROP TABLE IF EXISTS `system_event_logs`;
CREATE TABLE `system_event_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `level` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8mb4_unicode_ci,
  `details` mediumtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `system_event_logs_level_index` (`level`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of system_event_logs
-- ----------------------------
BEGIN;
INSERT INTO `system_event_logs` VALUES (1, 'error', 'Illuminate\\Encryption\\MissingAppKeyException: No application encryption key has been specified. in /www/summer/zero/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php:79\nStack trace:\n#0 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Support/helpers.php(306): Illuminate\\Encryption\\EncryptionServiceProvider->Illuminate\\Encryption\\{closure}(\'\')\n#1 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php(81): tap(\'\', Object(Closure))\n#2 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php(60): Illuminate\\Encryption\\EncryptionServiceProvider->key(Array)\n#3 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php(32): Illuminate\\Encryption\\EncryptionServiceProvider->parseKey(Array)\n#4 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(885): Illuminate\\Encryption\\EncryptionServiceProvider->Illuminate\\Encryption\\{closure}(Object(Winter\\Storm\\Foundation\\Application), Array)\n#5 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(770): Illuminate\\Container\\Container->build(Object(Closure))\n#6 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(856): Illuminate\\Container\\Container->resolve(\'encrypter\', Array, true)\n#7 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(706): Illuminate\\Foundation\\Application->resolve(\'encrypter\', Array)\n#8 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(841): Illuminate\\Container\\Container->make(\'encrypter\', Array)\n#9 /www/summer/zero/vendor/winter/storm/src/Foundation/Application.php(323): Illuminate\\Foundation\\Application->make(\'encrypter\')\n#10 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(1043): Winter\\Storm\\Foundation\\Application->make(\'encrypter\')\n#11 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(959): Illuminate\\Container\\Container->resolveClass(Object(ReflectionParameter))\n#12 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(920): Illuminate\\Container\\Container->resolveDependencies(Array)\n#13 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(770): Illuminate\\Container\\Container->build(\'Winter\\\\Storm\\\\Co...\')\n#14 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(856): Illuminate\\Container\\Container->resolve(\'Winter\\\\Storm\\\\Co...\', Array, true)\n#15 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(706): Illuminate\\Foundation\\Application->resolve(\'Winter\\\\Storm\\\\Co...\', Array)\n#16 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(841): Illuminate\\Container\\Container->make(\'Winter\\\\Storm\\\\Co...\', Array)\n#17 /www/summer/zero/vendor/winter/storm/src/Foundation/Application.php(323): Illuminate\\Foundation\\Application->make(\'Winter\\\\Storm\\\\Co...\')\n#18 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(169): Winter\\Storm\\Foundation\\Application->make(\'Winter\\\\Storm\\\\Co...\')\n#19 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#20 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#21 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request))\n#22 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route))\n#23 /www/summer/zero/vendor/winter/storm/src/Router/CoreRouter.php(20): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))\n#24 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(190): Winter\\Storm\\Router\\CoreRouter->dispatch(Object(Illuminate\\Http\\Request))\n#25 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request))\n#26 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#27 /www/summer/zero/vendor/winter/storm/src/Foundation/Http/Middleware/CheckForMaintenanceMode.php(25): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#28 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Winter\\Storm\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#29 /www/summer/zero/vendor/winter/storm/src/Foundation/Http/Middleware/CheckForTrustedProxies.php(56): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#30 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Winter\\Storm\\Foundation\\Http\\Middleware\\CheckForTrustedProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#31 /www/summer/zero/vendor/winter/storm/src/Http/Middleware/TrustHosts.php(46): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#32 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Winter\\Storm\\Http\\Middleware\\TrustHosts->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#33 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#34 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#35 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request))\n#36 /www/summer/zero/index.php(43): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request))\n#37 {main}', NULL, '2024-01-29 05:59:36', '2024-01-29 05:59:36');
INSERT INTO `system_event_logs` VALUES (2, 'error', 'Illuminate\\Encryption\\MissingAppKeyException: No application encryption key has been specified. in /www/summer/zero/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php:79\nStack trace:\n#0 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Support/helpers.php(306): Illuminate\\Encryption\\EncryptionServiceProvider->Illuminate\\Encryption\\{closure}(\'\')\n#1 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php(81): tap(\'\', Object(Closure))\n#2 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php(60): Illuminate\\Encryption\\EncryptionServiceProvider->key(Array)\n#3 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php(32): Illuminate\\Encryption\\EncryptionServiceProvider->parseKey(Array)\n#4 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(885): Illuminate\\Encryption\\EncryptionServiceProvider->Illuminate\\Encryption\\{closure}(Object(Winter\\Storm\\Foundation\\Application), Array)\n#5 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(770): Illuminate\\Container\\Container->build(Object(Closure))\n#6 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(856): Illuminate\\Container\\Container->resolve(\'encrypter\', Array, true)\n#7 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(706): Illuminate\\Foundation\\Application->resolve(\'encrypter\', Array)\n#8 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(841): Illuminate\\Container\\Container->make(\'encrypter\', Array)\n#9 /www/summer/zero/vendor/winter/storm/src/Foundation/Application.php(323): Illuminate\\Foundation\\Application->make(\'encrypter\')\n#10 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(1043): Winter\\Storm\\Foundation\\Application->make(\'encrypter\')\n#11 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(959): Illuminate\\Container\\Container->resolveClass(Object(ReflectionParameter))\n#12 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(920): Illuminate\\Container\\Container->resolveDependencies(Array)\n#13 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(770): Illuminate\\Container\\Container->build(\'Winter\\\\Storm\\\\Co...\')\n#14 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(856): Illuminate\\Container\\Container->resolve(\'Winter\\\\Storm\\\\Co...\', Array, true)\n#15 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(706): Illuminate\\Foundation\\Application->resolve(\'Winter\\\\Storm\\\\Co...\', Array)\n#16 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(841): Illuminate\\Container\\Container->make(\'Winter\\\\Storm\\\\Co...\', Array)\n#17 /www/summer/zero/vendor/winter/storm/src/Foundation/Application.php(323): Illuminate\\Foundation\\Application->make(\'Winter\\\\Storm\\\\Co...\')\n#18 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(239): Winter\\Storm\\Foundation\\Application->make(\'Winter\\\\Storm\\\\Co...\')\n#19 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(203): Illuminate\\Foundation\\Http\\Kernel->terminateMiddleware(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))\n#20 /www/summer/zero/index.php(48): Illuminate\\Foundation\\Http\\Kernel->terminate(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))\n#21 {main}', NULL, '2024-01-29 05:59:36', '2024-01-29 05:59:36');
INSERT INTO `system_event_logs` VALUES (3, 'error', 'Illuminate\\Encryption\\MissingAppKeyException: No application encryption key has been specified. in /www/summer/zero/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php:79\nStack trace:\n#0 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Support/helpers.php(306): Illuminate\\Encryption\\EncryptionServiceProvider->Illuminate\\Encryption\\{closure}(\'\')\n#1 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php(81): tap(\'\', Object(Closure))\n#2 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php(60): Illuminate\\Encryption\\EncryptionServiceProvider->key(Array)\n#3 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php(32): Illuminate\\Encryption\\EncryptionServiceProvider->parseKey(Array)\n#4 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(885): Illuminate\\Encryption\\EncryptionServiceProvider->Illuminate\\Encryption\\{closure}(Object(Winter\\Storm\\Foundation\\Application), Array)\n#5 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(770): Illuminate\\Container\\Container->build(Object(Closure))\n#6 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(856): Illuminate\\Container\\Container->resolve(\'encrypter\', Array, true)\n#7 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(706): Illuminate\\Foundation\\Application->resolve(\'encrypter\', Array)\n#8 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(841): Illuminate\\Container\\Container->make(\'encrypter\', Array)\n#9 /www/summer/zero/vendor/winter/storm/src/Foundation/Application.php(323): Illuminate\\Foundation\\Application->make(\'encrypter\')\n#10 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(1043): Winter\\Storm\\Foundation\\Application->make(\'encrypter\')\n#11 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(959): Illuminate\\Container\\Container->resolveClass(Object(ReflectionParameter))\n#12 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(920): Illuminate\\Container\\Container->resolveDependencies(Array)\n#13 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(770): Illuminate\\Container\\Container->build(\'Winter\\\\Storm\\\\Co...\')\n#14 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(856): Illuminate\\Container\\Container->resolve(\'Winter\\\\Storm\\\\Co...\', Array, true)\n#15 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(706): Illuminate\\Foundation\\Application->resolve(\'Winter\\\\Storm\\\\Co...\', Array)\n#16 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(841): Illuminate\\Container\\Container->make(\'Winter\\\\Storm\\\\Co...\', Array)\n#17 /www/summer/zero/vendor/winter/storm/src/Foundation/Application.php(323): Illuminate\\Foundation\\Application->make(\'Winter\\\\Storm\\\\Co...\')\n#18 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(169): Winter\\Storm\\Foundation\\Application->make(\'Winter\\\\Storm\\\\Co...\')\n#19 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#20 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#21 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request))\n#22 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route))\n#23 /www/summer/zero/vendor/winter/storm/src/Router/CoreRouter.php(20): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))\n#24 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(190): Winter\\Storm\\Router\\CoreRouter->dispatch(Object(Illuminate\\Http\\Request))\n#25 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request))\n#26 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#27 /www/summer/zero/vendor/winter/storm/src/Foundation/Http/Middleware/CheckForMaintenanceMode.php(25): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#28 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Winter\\Storm\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#29 /www/summer/zero/vendor/winter/storm/src/Foundation/Http/Middleware/CheckForTrustedProxies.php(56): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#30 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Winter\\Storm\\Foundation\\Http\\Middleware\\CheckForTrustedProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#31 /www/summer/zero/vendor/winter/storm/src/Http/Middleware/TrustHosts.php(46): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#32 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Winter\\Storm\\Http\\Middleware\\TrustHosts->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#33 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#34 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#35 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(134): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request))\n#36 /www/summer/zero/index.php(43): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request))\n#37 {main}', NULL, '2024-01-29 05:59:37', '2024-01-29 05:59:37');
INSERT INTO `system_event_logs` VALUES (4, 'error', 'Illuminate\\Encryption\\MissingAppKeyException: No application encryption key has been specified. in /www/summer/zero/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php:79\nStack trace:\n#0 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Support/helpers.php(306): Illuminate\\Encryption\\EncryptionServiceProvider->Illuminate\\Encryption\\{closure}(\'\')\n#1 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php(81): tap(\'\', Object(Closure))\n#2 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php(60): Illuminate\\Encryption\\EncryptionServiceProvider->key(Array)\n#3 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php(32): Illuminate\\Encryption\\EncryptionServiceProvider->parseKey(Array)\n#4 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(885): Illuminate\\Encryption\\EncryptionServiceProvider->Illuminate\\Encryption\\{closure}(Object(Winter\\Storm\\Foundation\\Application), Array)\n#5 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(770): Illuminate\\Container\\Container->build(Object(Closure))\n#6 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(856): Illuminate\\Container\\Container->resolve(\'encrypter\', Array, true)\n#7 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(706): Illuminate\\Foundation\\Application->resolve(\'encrypter\', Array)\n#8 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(841): Illuminate\\Container\\Container->make(\'encrypter\', Array)\n#9 /www/summer/zero/vendor/winter/storm/src/Foundation/Application.php(323): Illuminate\\Foundation\\Application->make(\'encrypter\')\n#10 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(1043): Winter\\Storm\\Foundation\\Application->make(\'encrypter\')\n#11 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(959): Illuminate\\Container\\Container->resolveClass(Object(ReflectionParameter))\n#12 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(920): Illuminate\\Container\\Container->resolveDependencies(Array)\n#13 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(770): Illuminate\\Container\\Container->build(\'Winter\\\\Storm\\\\Co...\')\n#14 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(856): Illuminate\\Container\\Container->resolve(\'Winter\\\\Storm\\\\Co...\', Array, true)\n#15 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Container/Container.php(706): Illuminate\\Foundation\\Application->resolve(\'Winter\\\\Storm\\\\Co...\', Array)\n#16 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(841): Illuminate\\Container\\Container->make(\'Winter\\\\Storm\\\\Co...\', Array)\n#17 /www/summer/zero/vendor/winter/storm/src/Foundation/Application.php(323): Illuminate\\Foundation\\Application->make(\'Winter\\\\Storm\\\\Co...\')\n#18 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(239): Winter\\Storm\\Foundation\\Application->make(\'Winter\\\\Storm\\\\Co...\')\n#19 /www/summer/zero/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(203): Illuminate\\Foundation\\Http\\Kernel->terminateMiddleware(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))\n#20 /www/summer/zero/index.php(48): Illuminate\\Foundation\\Http\\Kernel->terminate(Object(Illuminate\\Http\\Request), Object(Illuminate\\Http\\Response))\n#21 {main}', NULL, '2024-01-29 05:59:37', '2024-01-29 05:59:37');
COMMIT;

-- ----------------------------
-- Table structure for system_files
-- ----------------------------
DROP TABLE IF EXISTS `system_files`;
CREATE TABLE `system_files` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `disk_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_size` int(11) NOT NULL,
  `content_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attachment_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attachment_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_public` tinyint(1) NOT NULL DEFAULT '1',
  `sort_order` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `system_files_field_index` (`field`),
  KEY `system_files_attachment_id_index` (`attachment_id`),
  KEY `system_files_attachment_type_index` (`attachment_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for system_mail_layouts
-- ----------------------------
DROP TABLE IF EXISTS `system_mail_layouts`;
CREATE TABLE `system_mail_layouts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content_html` text COLLATE utf8mb4_unicode_ci,
  `content_text` text COLLATE utf8mb4_unicode_ci,
  `content_css` text COLLATE utf8mb4_unicode_ci,
  `is_locked` tinyint(1) NOT NULL DEFAULT '0',
  `options` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of system_mail_layouts
-- ----------------------------
BEGIN;
INSERT INTO `system_mail_layouts` VALUES (1, 'Default layout', 'default', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\n<head>\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />\n    <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />\n    <style type=\"text/css\" media=\"screen\">\n        {{ brandCss|raw }}\n        {{ css|raw }}\n    </style>\n</head>\n<body>\n    <table class=\"wrapper layout-default\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\n\n        <!-- Header -->\n        {% partial \'header\' body %}\n            {{ subject|raw }}\n        {% endpartial %}\n\n        <tr>\n            <td align=\"center\">\n                <table class=\"content\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\n                    <!-- Email Body -->\n                    <tr>\n                        <td class=\"body\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\n                            <table class=\"inner-body\" align=\"center\" width=\"570\" cellpadding=\"0\" cellspacing=\"0\">\n                                <!-- Body content -->\n                                <tr>\n                                    <td class=\"content-cell\">\n                                        {{ content|raw }}\n                                    </td>\n                                </tr>\n                            </table>\n                        </td>\n                    </tr>\n                </table>\n            </td>\n        </tr>\n\n        <!-- Footer -->\n        {% partial \'footer\' body %}\n            &copy; {{ \"now\"|date(\"Y\") }} {{ appName }}. All rights reserved.\n        {% endpartial %}\n\n    </table>\n\n</body>\n</html>', '{{ content|raw }}', '@media only screen and (max-width: 600px) {\n    .inner-body {\n        width: 100% !important;\n    }\n\n    .footer {\n        width: 100% !important;\n    }\n}\n\n@media only screen and (max-width: 500px) {\n    .button {\n        width: 100% !important;\n    }\n}', 1, NULL, '2024-01-29 05:49:29', '2024-01-29 05:49:29');
INSERT INTO `system_mail_layouts` VALUES (2, 'System layout', 'system', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\n<head>\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />\n    <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />\n    <style type=\"text/css\" media=\"screen\">\n        {{ brandCss|raw }}\n        {{ css|raw }}\n    </style>\n</head>\n<body>\n    <table class=\"wrapper layout-system\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\n        <tr>\n            <td align=\"center\">\n                <table class=\"content\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\n                    <!-- Email Body -->\n                    <tr>\n                        <td class=\"body\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\n                            <table class=\"inner-body\" align=\"center\" width=\"570\" cellpadding=\"0\" cellspacing=\"0\">\n                                <!-- Body content -->\n                                <tr>\n                                    <td class=\"content-cell\">\n                                        {{ content|raw }}\n\n                                        <!-- Subcopy -->\n                                        {% partial \'subcopy\' body %}\n                                            **This is an automatic message. Please do not reply to it.**\n                                        {% endpartial %}\n                                    </td>\n                                </tr>\n                            </table>\n                        </td>\n                    </tr>\n                </table>\n            </td>\n        </tr>\n    </table>\n\n</body>\n</html>', '{{ content|raw }}\n\n\n---\nThis is an automatic message. Please do not reply to it.', '@media only screen and (max-width: 600px) {\n    .inner-body {\n        width: 100% !important;\n    }\n\n    .footer {\n        width: 100% !important;\n    }\n}\n\n@media only screen and (max-width: 500px) {\n    .button {\n        width: 100% !important;\n    }\n}', 1, NULL, '2024-01-29 05:49:29', '2024-01-29 05:49:29');
COMMIT;

-- ----------------------------
-- Table structure for system_mail_partials
-- ----------------------------
DROP TABLE IF EXISTS `system_mail_partials`;
CREATE TABLE `system_mail_partials` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content_html` text COLLATE utf8mb4_unicode_ci,
  `content_text` text COLLATE utf8mb4_unicode_ci,
  `is_custom` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for system_mail_templates
-- ----------------------------
DROP TABLE IF EXISTS `system_mail_templates`;
CREATE TABLE `system_mail_templates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `content_html` text COLLATE utf8mb4_unicode_ci,
  `content_text` text COLLATE utf8mb4_unicode_ci,
  `layout_id` int(11) DEFAULT NULL,
  `is_custom` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `system_mail_templates_layout_id_index` (`layout_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for system_parameters
-- ----------------------------
DROP TABLE IF EXISTS `system_parameters`;
CREATE TABLE `system_parameters` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `namespace` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `group` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `item` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `item_index` (`namespace`,`group`,`item`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of system_parameters
-- ----------------------------
BEGIN;
INSERT INTO `system_parameters` VALUES (1, 'system', 'app', 'birthday', '\"2024-01-29T05:49:27.252839Z\"');
INSERT INTO `system_parameters` VALUES (2, 'system', 'update', 'count', '0');
INSERT INTO `system_parameters` VALUES (3, 'system', 'update', 'retry', '1706594492');
COMMIT;

-- ----------------------------
-- Table structure for system_plugin_history
-- ----------------------------
DROP TABLE IF EXISTS `system_plugin_history`;
CREATE TABLE `system_plugin_history` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `version` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `detail` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `system_plugin_history_code_index` (`code`),
  KEY `system_plugin_history_type_index` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=161 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of system_plugin_history
-- ----------------------------
BEGIN;
INSERT INTO `system_plugin_history` VALUES (1, 'Winter.Demo', 'comment', '1.0.1', 'First version of Demo', '2024-01-29 05:49:29');
INSERT INTO `system_plugin_history` VALUES (2, 'Winter.Builder', 'comment', '1.0.1', 'Initialize plugin.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (3, 'Winter.Builder', 'comment', '1.0.2', 'Fixes the problem with selecting a plugin. Minor localization corrections. Configuration files in the list and form behaviors are now autocomplete.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (4, 'Winter.Builder', 'comment', '1.0.3', 'Improved handling of the enum data type.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (5, 'Winter.Builder', 'comment', '1.0.4', 'Added user permissions to work with the Builder.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (6, 'Winter.Builder', 'comment', '1.0.5', 'Fixed permissions registration.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (7, 'Winter.Builder', 'comment', '1.0.6', 'Fixed front-end record ordering in the Record List component.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (8, 'Winter.Builder', 'comment', '1.0.7', 'Builder settings are now protected with user permissions. The database table column list is scrollable now. Minor code cleanup.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (9, 'Winter.Builder', 'comment', '1.0.8', 'Added the Reorder Controller behavior.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (10, 'Winter.Builder', 'comment', '1.0.9', 'Minor API and UI updates.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (11, 'Winter.Builder', 'comment', '1.0.10', 'Minor styling update.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (12, 'Winter.Builder', 'comment', '1.0.11', 'Fixed a bug where clicking placeholder in a repeater would open Inspector. Fixed a problem with saving forms with repeaters in tabs. Minor style fix.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (13, 'Winter.Builder', 'comment', '1.0.12', 'Added support for the Trigger property to the Media Finder widget configuration. Names of form fields and list columns definition files can now contain underscores.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (14, 'Winter.Builder', 'comment', '1.0.13', 'Minor styling fix on the database editor.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (15, 'Winter.Builder', 'comment', '1.0.14', 'Added support for published_at timestamp field', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (16, 'Winter.Builder', 'comment', '1.0.15', 'Fixed a bug where saving a localization string in Inspector could cause a JavaScript error. Added support for Timestamps and Soft Deleting for new models.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (17, 'Winter.Builder', 'comment', '1.0.16', 'Fixed a bug when saving a form with the Repeater widget in a tab could create invalid fields in the form\'s outside area. Added a check that prevents creating localization strings inside other existing strings.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (18, 'Winter.Builder', 'comment', '1.0.17', 'Added support Trigger attribute support for RecordFinder and Repeater form widgets.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (19, 'Winter.Builder', 'comment', '1.0.18', 'Fixes a bug where \'::class\' notations in a model class definition could prevent the model from appearing in the Builder model list. Added emptyOption property support to the dropdown form control.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (20, 'Winter.Builder', 'comment', '1.0.19', 'Added a feature allowing to add all database columns to a list definition. Added max length validation for database table and column names.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (21, 'Winter.Builder', 'comment', '1.0.20', 'Fixes a bug where form the builder could trigger the \"current.hasAttribute is not a function\" error.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (22, 'Winter.Builder', 'comment', '1.0.21', 'Back-end navigation sort order updated.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (23, 'Winter.Builder', 'comment', '1.0.22', 'Added scopeValue property to the RecordList component.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (24, 'Winter.Builder', 'comment', '1.0.23', 'Added support for balloon-selector field type, added Brazilian Portuguese translation, fixed some bugs', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (25, 'Winter.Builder', 'comment', '1.0.24', 'Added support for tag list field type, added read only toggle for fields. Prevent plugins from using reserved PHP keywords for class names and namespaces', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (26, 'Winter.Builder', 'comment', '1.0.25', 'Allow editing of migration code in the \"Migration\" popup when saving changes in the database editor.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (27, 'Winter.Builder', 'comment', '1.0.26', 'Allow special default values for columns and added new \"Add ID column\" button to database editor.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (28, 'Winter.Builder', 'comment', '1.0.27', 'Added ability to use \'scope\' in a form relation field, added ability to change the sort order of versions and added additional properties for repeater widget in form builder. Added Polish translation.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (29, 'Winter.Builder', 'script', '2.0.0', 'v2.0.0/convert_data.php', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (30, 'Winter.Builder', 'comment', '2.0.0', 'Rebrand to Winter.Builder', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (31, 'Winter.Builder', 'comment', '2.0.0', 'Fixes namespace parsing on php >= 8.0', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (32, 'Winter.Builder', 'comment', '2.0.1', 'Fixed missing icons in icon selection, rebranded icons to Winter.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (33, 'Winter.Builder', 'comment', '2.0.2', 'Added fields to control plugin replacement, PHP8 compatibility fixes.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (34, 'Winter.Builder', 'comment', '2.0.3', 'Added support for image columns', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (35, 'Winter.Builder', 'comment', '2.0.4', 'Added ability to modify Plugin replacement options. Automatically populate the model\'s `$jsonable` property for field types that require it. UX improvements.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (36, 'Winter.Builder', 'comment', '2.0.5', 'Fix issue with table selection when creating a model.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (37, 'Winter.Builder', 'comment', '2.0.6', 'Fix issues with JSON-able models, fix search functionality, fix automated tests.', '2024-01-29 06:02:38');
INSERT INTO `system_plugin_history` VALUES (38, 'Winter.User', 'script', '1.0.1', 'v1.0.1/create_users_table.php', '2024-01-29 06:11:11');
INSERT INTO `system_plugin_history` VALUES (39, 'Winter.User', 'script', '1.0.1', 'v1.0.1/create_throttle_table.php', '2024-01-29 06:11:11');
INSERT INTO `system_plugin_history` VALUES (40, 'Winter.User', 'comment', '1.0.1', 'Initialize plugin.', '2024-01-29 06:11:11');
INSERT INTO `system_plugin_history` VALUES (41, 'Winter.User', 'comment', '1.0.2', 'Seed tables.', '2024-01-29 06:11:11');
INSERT INTO `system_plugin_history` VALUES (42, 'Winter.User', 'comment', '1.0.3', 'Translated hard-coded text to language strings.', '2024-01-29 06:11:11');
INSERT INTO `system_plugin_history` VALUES (43, 'Winter.User', 'comment', '1.0.4', 'Improvements to user-interface for Location manager.', '2024-01-29 06:11:11');
INSERT INTO `system_plugin_history` VALUES (44, 'Winter.User', 'comment', '1.0.5', 'Added contact details for users.', '2024-01-29 06:11:11');
INSERT INTO `system_plugin_history` VALUES (45, 'Winter.User', 'script', '1.0.6', 'v1.0.6/create_mail_blockers_table.php', '2024-01-29 06:11:11');
INSERT INTO `system_plugin_history` VALUES (46, 'Winter.User', 'comment', '1.0.6', 'Added Mail Blocker utility so users can block specific mail templates.', '2024-01-29 06:11:11');
INSERT INTO `system_plugin_history` VALUES (47, 'Winter.User', 'comment', '1.0.7', 'Add back-end Settings page.', '2024-01-29 06:11:11');
INSERT INTO `system_plugin_history` VALUES (48, 'Winter.User', 'comment', '1.0.8', 'Updated the Settings page.', '2024-01-29 06:11:11');
INSERT INTO `system_plugin_history` VALUES (49, 'Winter.User', 'comment', '1.0.9', 'Adds new welcome mail message for users and administrators.', '2024-01-29 06:11:11');
INSERT INTO `system_plugin_history` VALUES (50, 'Winter.User', 'comment', '1.0.10', 'Adds administrator-only activation mode.', '2024-01-29 06:11:11');
INSERT INTO `system_plugin_history` VALUES (51, 'Winter.User', 'script', '1.0.11', 'v1.0.11/users_add_login_column.php', '2024-01-29 06:11:11');
INSERT INTO `system_plugin_history` VALUES (52, 'Winter.User', 'comment', '1.0.11', 'Users now have an optional login field that defaults to the email field.', '2024-01-29 06:11:11');
INSERT INTO `system_plugin_history` VALUES (53, 'Winter.User', 'script', '1.0.12', 'v1.0.12/users_rename_login_to_username.php', '2024-01-29 06:11:11');
INSERT INTO `system_plugin_history` VALUES (54, 'Winter.User', 'comment', '1.0.12', 'Create a dedicated setting for choosing the login mode.', '2024-01-29 06:11:11');
INSERT INTO `system_plugin_history` VALUES (55, 'Winter.User', 'comment', '1.0.13', 'Minor fix to the Account sign in logic.', '2024-01-29 06:11:11');
INSERT INTO `system_plugin_history` VALUES (56, 'Winter.User', 'comment', '1.0.14', 'Minor improvements to the code.', '2024-01-29 06:11:11');
INSERT INTO `system_plugin_history` VALUES (57, 'Winter.User', 'script', '1.0.15', 'v1.0.15/users_add_surname.php', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (58, 'Winter.User', 'comment', '1.0.15', 'Adds last name column to users table (surname).', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (59, 'Winter.User', 'comment', '1.0.16', 'Require permissions for settings page too.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (60, 'Winter.User', 'comment', '1.1.0', '!!! Profile fields and Locations have been removed.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (61, 'Winter.User', 'script', '1.1.1', 'v1.1.1/create_user_groups_table.php', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (62, 'Winter.User', 'script', '1.1.1', 'v1.1.1/seed_user_groups_table.php', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (63, 'Winter.User', 'comment', '1.1.1', 'Users can now be added to groups.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (64, 'Winter.User', 'comment', '1.1.2', 'A raw URL can now be passed as the redirect property in the Account component.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (65, 'Winter.User', 'comment', '1.1.3', 'Adds a super user flag to the users table, reserved for future use.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (66, 'Winter.User', 'comment', '1.1.4', 'User list can be filtered by the group they belong to.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (67, 'Winter.User', 'comment', '1.1.5', 'Adds a new permission to hide the User settings menu item.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (68, 'Winter.User', 'script', '1.2.0', 'v1.2.0/users_add_deleted_at.php', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (69, 'Winter.User', 'comment', '1.2.0', 'Users can now deactivate their own accounts.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (70, 'Winter.User', 'comment', '1.2.1', 'New feature for checking if a user is recently active/online.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (71, 'Winter.User', 'comment', '1.2.2', 'Add bulk action button to user list.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (72, 'Winter.User', 'comment', '1.2.3', 'Included some descriptive paragraphs in the Reset Password component markup.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (73, 'Winter.User', 'comment', '1.2.4', 'Added a checkbox for blocking all mail sent to the user.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (74, 'Winter.User', 'script', '1.2.5', 'v1.2.5/update_timestamp_nullable.php', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (75, 'Winter.User', 'comment', '1.2.5', 'Database maintenance. Updated all timestamp columns to be nullable.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (76, 'Winter.User', 'script', '1.2.6', 'v1.2.6/users_add_last_seen.php', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (77, 'Winter.User', 'comment', '1.2.6', 'Add a dedicated last seen column for users.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (78, 'Winter.User', 'comment', '1.2.7', 'Minor fix to user timestamp attributes.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (79, 'Winter.User', 'comment', '1.2.8', 'Add date range filter to users list. Introduced a logout event.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (80, 'Winter.User', 'comment', '1.2.9', 'Add invitation mail for new accounts created in the back-end.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (81, 'Winter.User', 'script', '1.3.0', 'v1.3.0/users_add_guest_flag.php', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (82, 'Winter.User', 'script', '1.3.0', 'v1.3.0/users_add_superuser_flag.php', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (83, 'Winter.User', 'comment', '1.3.0', 'Introduced guest user accounts.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (84, 'Winter.User', 'comment', '1.3.1', 'User notification variables can now be extended.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (85, 'Winter.User', 'comment', '1.3.2', 'Minor fix to the Auth::register method.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (86, 'Winter.User', 'comment', '1.3.3', 'Allow prevention of concurrent user sessions via the user settings.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (87, 'Winter.User', 'comment', '1.3.4', 'Added force secure protocol property to the account component.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (88, 'Winter.User', 'comment', '1.4.0', '!!! The Notifications tab in User settings has been removed.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (89, 'Winter.User', 'comment', '1.4.1', 'Added support for user impersonation.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (90, 'Winter.User', 'comment', '1.4.2', 'Fixes security bug in Password Reset component.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (91, 'Winter.User', 'comment', '1.4.3', 'Fixes session handling for AJAX requests.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (92, 'Winter.User', 'comment', '1.4.4', 'Fixes bug where impersonation touches the last seen timestamp.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (93, 'Winter.User', 'comment', '1.4.5', 'Added token fallback process to Account / Reset Password components when parameter is missing.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (94, 'Winter.User', 'comment', '1.4.6', 'Fixes Auth::register method signature mismatch with core Winter CMS Auth library', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (95, 'Winter.User', 'comment', '1.4.7', 'Fixes redirect bug in Account component / Update translations and separate user and group management.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (96, 'Winter.User', 'comment', '1.4.8', 'Fixes a bug where calling MailBlocker::removeBlock could remove all mail blocks for the user.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (97, 'Winter.User', 'comment', '1.5.0', '!!! Required password length is now a minimum of 8 characters. Previous passwords will not be affected until the next password change.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (98, 'Winter.User', 'script', '1.5.1', 'v1.5.1/users_add_ip_address.php', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (99, 'Winter.User', 'comment', '1.5.1', 'User IP addresses are now logged. Introduce registration throttle.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (100, 'Winter.User', 'comment', '1.5.2', 'Whitespace from usernames is now trimmed, allowed for username to be added to Reset Password mail templates.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (101, 'Winter.User', 'comment', '1.5.3', 'Fixes a bug in the user update functionality if password is not changed. Added highlighting for banned users in user list.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (102, 'Winter.User', 'comment', '1.5.4', 'Multiple translation improvements. Added view events to extend user preview and user listing toolbars.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (103, 'Winter.User', 'script', '2.0.0', 'v2.0.0/rename_tables.php', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (104, 'Winter.User', 'comment', '2.0.0', 'Rebrand to Winter.User', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (105, 'Winter.User', 'comment', '2.0.0', 'Update Russian language', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (106, 'Winter.User', 'script', '2.0.1', 'v2.0.1/rename_indexes.php', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (107, 'Winter.User', 'comment', '2.0.1', 'Rebrand table indexes', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (108, 'Winter.User', 'comment', '2.1.0', 'Enforce password length rules on sign in. Compatibility fixes.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (109, 'Winter.User', 'comment', '2.2.0', 'Add avatar removal. Password resets will activate users if User activation mode is enabled.', '2024-01-29 06:11:12');
INSERT INTO `system_plugin_history` VALUES (110, 'RLuders.Cors', 'comment', '1.0.0', 'First version of RLuders.Cors', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (111, 'RLuders.Cors', 'comment', '1.0.1', 'Fix the icon', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (112, 'RLuders.Cors', 'comment', '1.0.2', 'Fix plugin dependencies', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (113, 'RLuders.Cors', 'comment', '1.0.2', 'Fix English language', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (114, 'RLuders.Cors', 'comment', '1.0.2', 'Adds Brazilian Portuguese language', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (115, 'RLuders.Cors', 'comment', '1.0.2', 'Replace the namespace RLuders\\CORS to RLuders\\Cors', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (116, 'RLuders.Cors', 'comment', '1.0.3', 'Adds the middleware to the api Middleware Group', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (117, 'RLuders.Cors', 'comment', '1.0.4', 'Update dependencies', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (118, 'RLuders.Cors', 'comment', '1.0.5', 'Bug fixes', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (119, 'RLuders.Cors', 'comment', '1.0.6', 'Handeling composer dependencies', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (120, 'RLuders.JWTAuth', 'comment', '1.0.0', 'First version of JWTAuth', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (121, 'RLuders.JWTAuth', 'comment', '1.1.0', 'Settings support added', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (122, 'RLuders.JWTAuth', 'comment', '1.1.1', 'Ads JWTAuth Facade', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (123, 'RLuders.JWTAuth', 'comment', '1.1.1', 'Ads JWTFactory Facade', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (124, 'RLuders.JWTAuth', 'comment', '1.1.1', 'Tested with Winter CMS build 428 (Laravel 5.5 and last Winter.User 1.4.3)', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (125, 'RLuders.JWTAuth', 'comment', '1.1.2', 'Some email URL fixes', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (126, 'RLuders.JWTAuth', 'comment', '1.1.3', 'Adding the token refresh route', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (127, 'RLuders.JWTAuth', 'comment', '1.1.4', 'Small fix for the refresh route', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (128, 'RLuders.JWTAuth', 'comment', '1.1.4', 'Adding the user to the refresh route response', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (129, 'RLuders.JWTAuth', 'comment', '1.1.5', 'Using the loginAttribute from Winter.User', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (130, 'RLuders.JWTAuth', 'comment', '1.1.5', 'Adding support to Brazilian Portuguese', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (131, 'RLuders.JWTAuth', 'comment', '1.1.6', 'Handling with Blacklisted tokens', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (132, 'RLuders.JWTAuth', 'comment', '1.2.0', '!!! Upgrading the plugin and adding new features', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (133, 'RLuders.JWTAuth', 'comment', '1.2.1', 'Dependencies hotfix', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (134, 'RLuders.JWTAuth', 'comment', '1.2.2', 'License changes to GPLv3', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (135, 'RLuders.JWTAuth', 'comment', '1.2.3', 'Fix get user endpoint', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (136, 'RLuders.JWTAuth', 'comment', '1.2.4', '!!! Refresh token changes from PATCH to POST and now requires an data form parameter. Please, check the documentation or the UPDATED Postman collection.', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (137, 'RLuders.JWTAuth', 'comment', '1.2.5', 'Fix the validations issues', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (138, 'RLuders.JWTAuth', 'comment', '1.2.5', 'Fix issues when using RLuders.Cors Plugin', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (139, 'RLuders.JWTAuth', 'comment', '1.3.0', 'The AuthController was removed and splited into Single Action Controllers', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (140, 'RLuders.JWTAuth', 'comment', '1.3.0', 'Added some Traits to keep the code simple', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (141, 'RLuders.JWTAuth', 'comment', '1.3.0', 'Activate user by email is now working', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (142, 'RLuders.JWTAuth', 'comment', '1.3.0', 'Inactive users can\'t reset they passwords', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (143, 'RLuders.JWTAuth', 'comment', '1.3.0', 'German language', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (144, 'RLuders.JWTAuth', 'comment', '1.3.1', 'Small hotfix to fix the Carbon 2 incompatibility', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (145, 'RLuders.JWTAuth', 'comment', '1.3.2', 'Fix typo on JsonValidationException', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (146, 'RLuders.JWTAuth', 'comment', '1.3.3', 'Added Czech Language support', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (147, 'RLuders.JWTAuth', 'comment', '1.3.3', 'Mirror hotfixes', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (148, 'RLuders.JWTAuth', 'comment', '1.4.0', 'Dependencies updated', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (149, 'RLuders.JWTAuth', 'comment', '1.4.0', 'Gives you the possibity to overwrite the configuration file', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (150, 'RLuders.JWTAuth', 'comment', '1.4.0', 'Fix issues at register that was causing 500 errors when username was present at the request', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (151, 'RLuders.JWTAuth', 'comment', '1.4.0', 'Handle 500 error codes', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (152, 'RLuders.JWTAuth', 'comment', '1.4.1', 'Adding support to Laravel 6', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (153, 'RLuders.JWTAuth', 'comment', '1.4.1', 'Improving error handling', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (154, 'RLuders.JWTAuth', 'comment', '1.4.2', 'Fixes dependencies that was causing issues related to Carbon', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (155, 'RLuders.JWTAuth', 'comment', '1.4.3', '(REALLY) Fixes the dependencies.', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (156, 'RLuders.JWTAuth', 'comment', '1.4.4', 'Updates dependencies', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (157, 'RLuders.JWTAuth', 'comment', '1.4.4', 'Fix language support', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (158, 'RLuders.JWTAuth', 'comment', '1.4.4', 'Adds French language support', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (159, 'RLuders.JWTAuth', 'comment', '1.5.0', 'Updates dependencies - replaced tymon/jwt-auth with php-open-source-saver/jwt-auth', '2024-01-29 06:15:27');
INSERT INTO `system_plugin_history` VALUES (160, 'RLuders.JWTAuth', 'comment', '1.5.0', 'Adds jwt-auth related refactoring', '2024-01-29 06:15:27');
COMMIT;

-- ----------------------------
-- Table structure for system_plugin_versions
-- ----------------------------
DROP TABLE IF EXISTS `system_plugin_versions`;
CREATE TABLE `system_plugin_versions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `version` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `is_frozen` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `system_plugin_versions_code_index` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of system_plugin_versions
-- ----------------------------
BEGIN;
INSERT INTO `system_plugin_versions` VALUES (1, 'Winter.Demo', '1.0.1', '2024-01-29 05:49:29', 0, 0);
INSERT INTO `system_plugin_versions` VALUES (2, 'Winter.Builder', '2.0.6', '2024-01-29 06:02:38', 0, 0);
INSERT INTO `system_plugin_versions` VALUES (3, 'Winter.User', '2.2.0', '2024-01-29 06:11:12', 0, 0);
INSERT INTO `system_plugin_versions` VALUES (4, 'RLuders.Cors', '1.0.6', '2024-01-29 06:15:27', 0, 0);
INSERT INTO `system_plugin_versions` VALUES (5, 'RLuders.JWTAuth', '1.5.0', '2024-01-29 06:15:27', 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for system_request_logs
-- ----------------------------
DROP TABLE IF EXISTS `system_request_logs`;
CREATE TABLE `system_request_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `status_code` int(11) DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referer` text COLLATE utf8mb4_unicode_ci,
  `count` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for system_revisions
-- ----------------------------
DROP TABLE IF EXISTS `system_revisions`;
CREATE TABLE `system_revisions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned DEFAULT NULL,
  `field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cast` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `old_value` text COLLATE utf8mb4_unicode_ci,
  `new_value` text COLLATE utf8mb4_unicode_ci,
  `revisionable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `revisionable_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `system_revisions_revisionable_id_revisionable_type_index` (`revisionable_id`,`revisionable_type`),
  KEY `system_revisions_user_id_index` (`user_id`),
  KEY `system_revisions_field_index` (`field`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for system_settings
-- ----------------------------
DROP TABLE IF EXISTS `system_settings`;
CREATE TABLE `system_settings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `item` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `system_settings_item_index` (`item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for user_groups
-- ----------------------------
DROP TABLE IF EXISTS `user_groups`;
CREATE TABLE `user_groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_groups_code_index` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of user_groups
-- ----------------------------
BEGIN;
INSERT INTO `user_groups` VALUES (1, 'Guest', 'guest', 'Default group for guest users.', '2024-01-29 06:11:12', '2024-01-29 06:11:12');
INSERT INTO `user_groups` VALUES (2, 'Registered', 'registered', 'Default group for registered users.', '2024-01-29 06:11:12', '2024-01-29 06:11:12');
COMMIT;

-- ----------------------------
-- Table structure for user_throttle
-- ----------------------------
DROP TABLE IF EXISTS `user_throttle`;
CREATE TABLE `user_throttle` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned DEFAULT NULL,
  `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attempts` int(11) NOT NULL DEFAULT '0',
  `last_attempt_at` timestamp NULL DEFAULT NULL,
  `is_suspended` tinyint(1) NOT NULL DEFAULT '0',
  `suspended_at` timestamp NULL DEFAULT NULL,
  `is_banned` tinyint(1) NOT NULL DEFAULT '0',
  `banned_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_throttle_user_id_index` (`user_id`),
  KEY `user_throttle_ip_address_index` (`ip_address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `activation_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `persist_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reset_password_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `permissions` text COLLATE utf8mb4_unicode_ci,
  `is_activated` tinyint(1) NOT NULL DEFAULT '0',
  `activated_at` timestamp NULL DEFAULT NULL,
  `last_login` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `surname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `last_seen` timestamp NULL DEFAULT NULL,
  `is_guest` tinyint(1) NOT NULL DEFAULT '0',
  `is_superuser` tinyint(1) NOT NULL DEFAULT '0',
  `created_ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_login_unique` (`username`),
  KEY `users_activation_code_index` (`activation_code`),
  KEY `users_reset_password_code_index` (`reset_password_code`),
  KEY `users_login_index` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for users_groups
-- ----------------------------
DROP TABLE IF EXISTS `users_groups`;
CREATE TABLE `users_groups` (
  `user_id` int(10) unsigned NOT NULL,
  `user_group_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`user_id`,`user_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for winter_user_mail_blockers
-- ----------------------------
DROP TABLE IF EXISTS `winter_user_mail_blockers`;
CREATE TABLE `winter_user_mail_blockers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `template` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `rainlab_user_mail_blockers_email_index` (`email`),
  KEY `rainlab_user_mail_blockers_template_index` (`template`),
  KEY `rainlab_user_mail_blockers_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

SET FOREIGN_KEY_CHECKS = 1;
